Sub-question:

  1. What is the impact of Covid19 on the average movements of Dutch residence?
  2. Which area of Netherlands would have the residence that is more willing to travel?
  3. Which area whose number of average movements are influenced by covid19 most?

Geographic data needed for visualization

In order to uderstand the average movements distriution per area in Netherlands, so this section, the geometry information of Netherlands has been extracted and cleaned so that it can be used by package geopandas. Moreover, this would help figure out the area where the people's trips are influenced by Covid19 most. For the more detailed data, you can check notebook Simmon's Visualization.

The right red map is the one that we gonna use in visualization

Input the data that shows average movements per person per year per area

This section we manage the dataset obtained from CBS to show the number of average movements.

An obvious drop for the average trips per person per region in Netherlands can be found in 2020 when the serious lockdown regulation was published by government.

Combine the movements data per region with the geographic data, and show the overall movements of residence per region per year in the Netherlands geographically

The detailed map of Netherlands including the name of each province is shown below.

Netherlands map

We display the map with distribution of average trips per person of each region of Netherlands from 2018 to 2021 to see if some regions are affected by the COVID 19 heavily (see Figures above). The Geo and shapefile data of Netherlands are extracted from gadm.org and they are also cleaned before being applied to plot.

Based on the maps, we found the regions Drenthe, Overijssel and Gelderland(yellow regions in map) are the areas where people are more willing to move around compared with people from other regions. Drenthe is the area where the residence's trips are influenced by the COVID 19 lockdown most as the value range that they belong to change from 1010.83-1027 to 866-883.33(as well as color representation changing from yellow to green), which means a sort of downgrading. But the average trips in Friesland is interesting to be found that it increased a bit during pandemic.